-- Create test case
DECLARE @myDateTime DATETIME
SET @myDateTime = '2008-05-03'
-- Convert string
SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)
SELECT convert(datetime, '09/10/2019', 101);
SELECT convert(datetime, '09/10/2019', 101);